Error: #N/A! displays because formula refers to a cell with no value.
Error:
#N/A!
Cause:
The formula refers to a cell that does not have a value in it.
Solution:
Type a value in the
cell
and recalculate the formula.
